Forum: SQL & PL/SQL «»
Posted on: Thu, 03 July 2008 00:22 «»
By:janardhanam.k Re: query with rank function
…
AND utrbase_styp_code NOT IN ('FRB','WAC','FRC')) rec
WHERE rank = 1
order by
rec.utrasup_supplement_band_code,
rec.utrasup_srvc_code,
rec.from_date…
2
Forum: SQL & PL/SQL «»
Posted on: Wed, 02 July 2008 23:27 «»
By:janardhanam.k Re: query with rank function
…
AND utrbase_styp_code NOT IN ('FRB','WAC','FRC')) rec
WHERE rank = 1
order by
rec.utrasup_supplement_band_code,
rec.utrasup_srvc_code,
rec.from_date…
3
Forum: SQL & PL/SQL «»
Posted on: Tue, 01 July 2008 07:47 «»
By:janardhanam.k query with rank function
…
AND utrbase_styp_code NOT IN ('FRB','WAC','FRC')) rec
WHERE rank = 1
order by
rec.utrasup_supplement_band_code,
rec.utrasup_srvc_code,
rec.from_date…
4
Forum: SQL & PL/SQL «»
Posted on: Wed, 31 March 2004 02:23 «»
By:Ken Jones DBMS_SPACE
…Guys,
I have a table called BRANDS in the FRB schema on my 9204 database running on Solaris 6.
I run the following command but it errors:-
1 DECLARE
2 segown VARCHAR2(30) := 'FRB';
3 segname VARCHAR2(30) := 'BRANDS';
4 segtype VARCHA…
5
Forum: Server Utilities «»
Posted on: Tue, 09 March 2004 06:15 «»
By:Mahesh Rajendran Re: Import data only
…the tables before loading, data will be appended and if there are any constraints ont he table, it may be violated.
imp frb/frb@frbtest file=frbprd.frb_full_040309.dmp grants=n indexes=n rows=y log=frbprd.frb_full_040309.log constraints=n ignore=y…
6
Forum: Server Utilities «»
Posted on: Tue, 09 March 2004 05:59 «»
By:Ken Jones Import data only
… just import data. Here is my command:-
imp frb/frb@frbtest file=frbprd.frb_full_040309.dmp grants=n indexes=n rows=y log=frbprd.frb_full_040309.log constraints=n
I get create errors as the objects are already there but I do not want to create the …
Blog
Search
Help
Members
Register
Login
Home